/*
 Navicat Premium Data Transfer

 Source Server         : localhost_3306
 Source Server Type    : MySQL
 Source Server Version : 80032 (8.0.32)
 Source Host           : localhost:3306
 Source Schema         : renli_manager

 Target Server Type    : MySQL
 Target Server Version : 80032 (8.0.32)
 File Encoding         : 65001

 Date: 27/03/2023 20:56:19
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for staff
-- ----------------------------
DROP TABLE IF EXISTS `staff`;
CREATE TABLE `staff` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '每位员工都有对应的id，不能为空，且不能重复',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '姓名',
  `sex` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '性别',
  `school_record` varchar(255) DEFAULT NULL COMMENT '学历',
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '邮箱',
  `addr` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '地址',
  `political_outlook` varchar(255) DEFAULT NULL COMMENT '政治面貌',
  `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '电话',
  `graduate_school` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '毕业院校',
  `create_time` datetime NOT NULL COMMENT '创建信息时间',
  `update_time` datetime NOT NULL COMMENT '修改信息时间',
  `update_people` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '修改人',
  `create_people` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '创建人',
  `position` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '职位',
  PRIMARY KEY (`id`),
  UNIQUE KEY `电话` (`phone`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1639965997678182403 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of staff
-- ----------------------------
BEGIN;
INSERT INTO `staff` (`id`, `name`, `sex`, `school_record`, `email`, `addr`, `political_outlook`, `phone`, `graduate_school`, `create_time`, `update_time`, `update_people`, `create_people`, `position`) VALUES (3, '林先知', '男', '本科', '283@163.com', '老北京', '共青团员', '12321425162', '清华', '2023-03-04 20:16:08', '2023-03-21 19:37:26', '待定', '12423423', '总经理');
INSERT INTO `staff` (`id`, `name`, `sex`, `school_record`, `email`, `addr`, `political_outlook`, `phone`, `graduate_school`, `create_time`, `update_time`, `update_people`, `create_people`, `position`) VALUES (8, '李六', '女', '大专', '2334@163.com', '福建山旮旯', '务农', '2143242', '福建清华大学', '2023-03-08 20:15:58', '2023-03-23 20:16:01', '234', '2143242', '老板');
INSERT INTO `staff` (`id`, `name`, `sex`, `school_record`, `email`, `addr`, `political_outlook`, `phone`, `graduate_school`, `create_time`, `update_time`, `update_people`, `create_people`, `position`) VALUES (1638083918693437443, '啦', '男', '大学', '345', '35tyb', 'gfb', 'r34535', 'rbrtbtr', '2023-03-16 19:20:28', '2023-03-07 19:20:19', 'rbrtb', 'rtb', 'rtgret');
INSERT INTO `staff` (`id`, `name`, `sex`, `school_record`, `email`, `addr`, `political_outlook`, `phone`, `graduate_school`, `create_time`, `update_time`, `update_people`, `create_people`, `position`) VALUES (1638083918693437444, 'fv', 'dfv', 'dfv', 'dfv', 'dfv', 'dfv', 'rtbt', 'rtb', '2023-03-21 19:21:24', '2023-03-14 19:21:27', 'rb', 'brb', 'dfvb');
INSERT INTO `staff` (`id`, `name`, `sex`, `school_record`, `email`, `addr`, `political_outlook`, `phone`, `graduate_school`, `create_time`, `update_time`, `update_people`, `create_people`, `position`) VALUES (1639196442747977730, '徐先知', '男', '本科', '23245@qq.com', '福建南岭', '团圆', '13143423669', '清华小学', '2023-03-24 17:24:21', '2023-03-24 17:41:43', 'root', '徐先知', '总经理');
INSERT INTO `staff` (`id`, `name`, `sex`, `school_record`, `email`, `addr`, `political_outlook`, `phone`, `graduate_school`, `create_time`, `update_time`, `update_people`, `create_people`, `position`) VALUES (1639883785855287298, '林大小', '女', '博士', '23245@qq.com', '上海南岭', '支书', '15143423669', '清华二中', '2023-03-26 14:55:37', '2023-03-26 14:55:37', 'root', 'root', '总经理');
INSERT INTO `staff` (`id`, `name`, `sex`, `school_record`, `email`, `addr`, `political_outlook`, `phone`, `graduate_school`, `create_time`, `update_time`, `update_people`, `create_people`, `position`) VALUES (1639893761873092610, '徐先知', '男', '本科', '23245@qq.com', '福建南岭', '团圆', '13143423639', '清华小学', '2023-03-26 15:35:15', '2023-03-26 15:35:15', 'root', 'root', '总经理');
INSERT INTO `staff` (`id`, `name`, `sex`, `school_record`, `email`, `addr`, `political_outlook`, `phone`, `graduate_school`, `create_time`, `update_time`, `update_people`, `create_people`, `position`) VALUES (1639893783121436673, '徐先知', '男', '本科', '23245@qq.com', '福建南岭', '团圆', '13146423639', '清华小学', '2023-03-26 15:35:20', '2023-03-26 15:35:20', 'root', 'root', '总经理');
INSERT INTO `staff` (`id`, `name`, `sex`, `school_record`, `email`, `addr`, `political_outlook`, `phone`, `graduate_school`, `create_time`, `update_time`, `update_people`, `create_people`, `position`) VALUES (1639893804017459201, '徐先知', '男', '本科', '23245@qq.com', '福建南岭', '团圆', '13246423639', '清华小学', '2023-03-26 15:35:25', '2023-03-26 15:35:25', 'root', 'root', '总经理');
INSERT INTO `staff` (`id`, `name`, `sex`, `school_record`, `email`, `addr`, `political_outlook`, `phone`, `graduate_school`, `create_time`, `update_time`, `update_people`, `create_people`, `position`) VALUES (1639893824196255745, '徐先知', '男', '本科', '23245@qq.com', '福建南岭', '团圆', '13246423630', '清华小学', '2023-03-26 15:35:30', '2023-03-26 15:35:30', 'root', 'root', '总经理');
INSERT INTO `staff` (`id`, `name`, `sex`, `school_record`, `email`, `addr`, `political_outlook`, `phone`, `graduate_school`, `create_time`, `update_time`, `update_people`, `create_people`, `position`) VALUES (1639893842714107906, '测试', '男', '本科', '23245@qq.com', '福建南岭', '团圆', '13143424669', '清华小学', '2023-03-26 15:35:35', '2023-03-26 20:14:20', 'root', 'root', '董事长');
INSERT INTO `staff` (`id`, `name`, `sex`, `school_record`, `email`, `addr`, `political_outlook`, `phone`, `graduate_school`, `create_time`, `update_time`, `update_people`, `create_people`, `position`) VALUES (1639965997678182402, '测试3', '女', '本科', '23245@qq.com', '福建南岭', '团圆', '13143424169', '清华小学', '2023-03-26 20:22:18', '2023-03-26 20:22:18', 'root', 'root', '董事长');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
